| Column | Data Type | Nullable | Default | Description |
| ProductID | int | not null | | Primary key. Foreign key to Product.ProductID. |
| VendorID | int | not null | | Primary key. Foreign key to Vendor.VendorID. |
| AverageLeadTime | int | not null | | The average span of time (in days) between placing an order with the vendor and receiving the purchased product. |
| StandardPrice | money | not null | | The vendor's usual selling price. |
| LastReceiptCost | money | null | | The selling price when last purchased. |
| LastReceiptDate | datetime | null | | Date the product was last received by the vendor. |
| MinOrderQty | int | not null | | The maximum quantity that should be ordered. |
| MaxOrderQty | int | not null | | The minimum quantity that should be ordered. |
| OnOrderQty | int | null | | The quantity currently on order. |
| UnitMeasureCode | nchar(3) | not null | | The product's unit of measure. |
| ModifiedDate | datetime | not null | (getdate()) | Date and time the record was last updated. |